oracle substring 在 Oracle substring - Stack Overflow 的評價 Use REGEXP_SUBSTR with the regex pattern H-([_;]+) , then replace with the first capture group: SELECT REGEXP_SUBSTR('H-Henry Grey;CA;UID123 ... ... <看更多>
